| SaACHConfig |
| Logical Entity Name | SaACHConfig |
| Default Table Name | SaACHConfig |
| Physical Only | NO |
| Definition | |
| Note |
| SaACHConfig Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaACHConfigID |
int | NO | ||
| SaACHConfigCode | varchar(10) | YES | ||
| SaACHConfigDescrip | varchar(35) | YES | ||
| InitialBatchNumber | int | YES | ||
| InitialTxNumber | int | YES | ||
| FileName | varchar(256) | YES | ||
| FolderName | varchar(256) | YES | ||
| ImmediateDestID | varchar(30) | YES | ||
| ImmediateOriginID | varchar(10) | YES | ||
| ImmediateOriginName | varchar(23) | YES | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| Ts | timestamp | NO | ||
SyStaffGroupID |
int | YES | ||
| ImmediateDestName | varchar(23) | YES | ||
| UseForPayment | bit | YES | ||
| UseforRefund | bit | YES | ||
| OriginatingDFI | varchar(8) | YES |
| SaACHConfig Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SaACHConfig_SaACHConfigID_U_C_IDX | PrimaryKey | SaACHConfigID |
| SaACHConfig Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| SyStaffGroup | Non-Identifying | Zero or One to Zero or More | FK_SaACHConfig_SyStaffGroupID_SyStaffGroup_SyStaffGroupID | SyStaffGroupID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_SaACHConfig_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaACHBatch | Non-Identifying | One To Zero or More | FK_SaACHBatch_SaACHConfigID_SaACHConfig_SaACHConfigID | NO | YES | |||
| SaACHConfigCampus | Non-Identifying | One To Zero or More | FK_SaACHConfigCampus_SaACHConfigID_SaACHConfig_SaACHConfigID | NO | YES |
| SaACHConfig Check Constraints |
| Check Constraint Name | CheckConstraint |